[dbo].[BAEEventSetupRemoveGroup]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEEventSetupRemoveGroup

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@eventCode	varchar(15)	15
@groupName	varchar(15)	15

SQL Script

create procedure [dbo].[BAEEventSetupRemoveGroup] @eventCode varchar(15),
     @groupName varchar(15) as
DELETE FROM EventSetupFunctionGroup
    WHERE EventCode = @eventCode AND GroupName = @groupName;
    DELETE FROM EventSetupGroup
    WHERE EventCode = @eventCode AND GroupName = @groupName;

GO

Uses

[dbo].[EventSetupFunctionGroup]
[dbo].[EventSetupGroup]
dbo